<%
response.setHeader("Cache-Control","no-cache");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
response.setHeader("Content-type","application/vnd.ms-excel");
response.setHeader("Content-disposition","inline; filename=REPORTE.xls");
%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@ page language="java" import='java.util.ArrayList'%>
<%@ page language="java" import='java.util.List'%>
<%@ page language="java" import='com.dgac.licencias.to.*'%>
<%@ page language="java" import='java.text.DecimalFormat'%>
<html><head><title>LISTADO DE CLIENTES</title>
<meta http-equiv="Content-Type" content="text/html; charset=unicode"><link 
href="/WebLicencias/css/espacio.css" type=text/css rel=stylesheet>
<link 
href="/WebLicencias/css/calendar-system.css" type=text/css rel=stylesheet>
<script language="javascript" src="/WebLicencias/js/calendar.js"></script>
<script language="javascript" type="text/javascript" src="/WebLicencias/js/js.Farmacia.Function.js"></script>
<script language="javascript" src="/WebLicencias/js/calendar-es.js"></script>
<script language="javascript" src="/WebLicencias/js/utils.js"></script>


<meta content="MSHTML 6.00.6000.16939" name="GENERATOR"></head>
<body>

<div id="idTabla2" style="DISPLAY: inline">
<table width="98%" align="center" bgcolor="#fffdd6" border="0">
  <tbody>
    <tr><td> <div class="Titulo1B" align="center">LICENCIAS VENCIDAS</div></td>
   </tr>   
  <tr>
    <td>
      <div id="res"> <br>
      <table class="consultanormal" id="row" cellspacing="0" width="98%" 
        align=center><thead>
        <tr>
          <th class="sortable" width="8%"><a href="#"><font color="#ffffff">No 
            Licencia</font></a></th>
          <th class="sortable" width="20%"><a href="#"><font 
            color=#ffffff>Tipo&nbsp;</font></a></th>
          <th class="sortable" width="10%"><a href="#"><font color="#ffffff">Fecha 
            Vencimiento</font></a></th>
          <th class="sortable" width="30%"><a href="#"><font 
            color=#ffffff>Cliente</font></a></th>
          <th class="sortable" width="10%"><a href="#"><font color="#ffffff">Fecha Otorg.</font></a></th>
          <th class="sortable" width="10%"><a href="#"><font color="#ffffff">No 
            Documento</font></a></th></tr></thead>
        <tbody>
            
         <%
           ArrayList listclilic = (ArrayList) request.getSession().getAttribute("listClienteLicencias2");
           int hits=0;
           if (listclilic!=null) {
           hits=listclilic.size(); 
           for (int i = 0; i < listclilic.size(); i++) {
                    ClientelicenciaTO clilic = (ClientelicenciaTO) listclilic.get(i);
                    String[] clase = {"odd","even"};
         %>
        
        <tr class="<%=(clase[i%2])%>">
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getNumLic() %></div></td>
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getLicenciaTO().getDescripcion() %></div></td>
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getFechaVcmnto() %></div></td>
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getClienteTO().getNombreCompleto()  %></div></td>
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getSfechaOtorgamiento() %></div></td>
          <td class="TextoTabla8">
            <div align="center"><%=clilic.getClienteTO().getNumIdDoc() %></div></td></tr>
             <%
          }
        }
           if(hits==0){
            %>
            <tr class="odd">
          <td>
            <div align="center">&nbsp;</div></td>
          <td class="TextoTabla8">
            <div align="center">&nbsp;</div></td>
          <td class="TextoTabla8">
            <div align="center">&nbsp;</div></td>
          <td class="TextoTabla8">
            <div align="center">&nbsp;</div></td>
          <td class="TextoTabla8">
            <div align="center">&nbsp;</div></td>
          <td class="TextoTabla8">
            <div align="center">&nbsp;</div></td>
           </tr>
            <%}%>
            </tbody></table><br>
     <br><br></div></td></tr></tbody></table></div>
</body></html>

